BetterAlt Uk
Owner: tanya.sharma@oneguardian.in · Better Alt · ← all brands
Active days
21
Sessions
249
Active hours
5.30
real mouse/keyboard time
Page views
39
Actions
10
Entities changed
10
Action mix
Bid
10
Budget
0
Status
0
Rule
0
Scheduler
0
Current automation state
Rules
0 / 0
active / total — 0 paused, 0 expired
Dayparting
0 / 0
active / total — 0 paused, 0 expired
Managers
0
Executives
0
Sellers
1
Vendors
0
Profile 2801064747687720
· amazon
· europe
Top users on this brand
| Name | Role | Sessions | Active min | |
|---|---|---|---|---|
| tanya.sharma@oneguardian.in | Tanya | Admin | 249 | 318.1 |
Daily
| Day | Users | Sessions | Active hours | Page views | Actions | Entities |
|---|---|---|---|---|---|---|
| 2026-05-26 | 1 | 16 | 0.21 | 1 | 0 | 0 |
| 2026-05-27 | 1 | 14 | 0.20 | 1 | 0 | 0 |
| 2026-05-28 | 1 | 13 | 0.23 | 6 | 0 | 0 |
| 2026-05-29 | 1 | 13 | 0.22 | 2 | 0 | 0 |
| 2026-05-31 | 1 | 25 | 0.12 | 0 | 0 | 0 |
| 2026-06-01 | 1 | 14 | 0.38 | 0 | 0 | 0 |
| 2026-06-02 | 1 | 34 | 1.35 | 6 | 5 | 5 |
| 2026-06-03 | 1 | 24 | 0.46 | 7 | 0 | 0 |
| 2026-06-04 | 1 | 13 | 0.22 | 3 | 0 | 0 |
| 2026-06-05 | 1 | 4 | 0.09 | 0 | 0 | 0 |
| 2026-06-08 | 1 | 10 | 0.40 | 3 | 5 | 5 |
| 2026-06-09 | 1 | 10 | 0.23 | 1 | 0 | 0 |
| 2026-06-12 | 1 | 6 | 0.09 | 1 | 0 | 0 |
| 2026-06-15 | 1 | 8 | 0.19 | 0 | 0 | 0 |
| 2026-06-16 | 1 | 3 | 0.03 | 0 | 0 | 0 |
| 2026-06-17 | 1 | 1 | 0.02 | 1 | 0 | 0 |
| 2026-06-18 | 1 | 14 | 0.32 | 5 | 0 | 0 |
| 2026-06-19 | 1 | 3 | 0.04 | 0 | 0 | 0 |
| 2026-06-22 | 1 | 3 | 0.06 | 1 | 0 | 0 |
| 2026-06-24 | 1 | 4 | 0.10 | 0 | 0 | 0 |
| 2026-06-25 | 1 | 17 | 0.36 | 1 | 0 | 0 |
4 queries · scanned 28.87 MB · cost $0.000172 · 6.72s
SELECT brand_group,
ANY_VALUE(profile_owner_email) AS profile_owner_email,
ANY_VALUE(company_name) AS company_name,
SUM(distinct_users) AS user_day_rows,
COUNT(DISTINCT day) AS active_days,
SUM(sessions) AS sessions,
SUM(active_seconds) AS active_seconds,
SUM(page_views) AS page_views,
SUM(action_count) AS action_count,
SUM(entity_count) AS entity_count,
SUM(bid_actions) AS bid_actions,
SUM(budget_actions) AS budget_actions,
SUM(status_actions) AS status_actions,
SUM(rule_actions) AS rule_actions,
SUM(scheduler_actions) AS scheduler_actions
FROM `amazoneast.customerio_data.vw_brand_day_overview`
WHERE LOWER(brand_group) = LOWER('BetterAlt Uk')
AND day BETWEEN DATE '2026-05-26' AND DATE '2026-06-25'
GROUP BY brand_group
SELECT email,
ANY_VALUE(full_name) AS full_name,
ANY_VALUE(role) AS role,
SUM(sessions) AS sessions,
ROUND(SUM(active_seconds)/60.0, 1) AS active_min
FROM `amazoneast.customerio_data.fact_sessions_daily`
WHERE LOWER(brand_group) = LOWER('BetterAlt Uk')
AND day BETWEEN DATE '2026-05-26' AND DATE '2026-06-25'
GROUP BY email
ORDER BY active_min DESC
LIMIT 5000
SELECT day,
distinct_users,
sessions,
ROUND(active_hours, 2) AS active_hours,
page_views, action_count, entity_count
FROM `amazoneast.customerio_data.vw_brand_day_overview`
WHERE LOWER(brand_group) = LOWER('BetterAlt Uk')
AND day BETWEEN DATE '2026-05-26' AND DATE '2026-06-25'
ORDER BY day
SELECT *
FROM `amazoneast.customerio_data.vw_brand_state`
WHERE LOWER(brand_group) = LOWER('BetterAlt Uk')
LIMIT 5